package com.depthsdata.coe.dao;
import java.util.Arrays;
import java.util.List;
import java.util.Map;
import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;
import org.apache.commons.lang.StringUtils;
/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2019-12-27 11:41:50
  * Warning ! This file will be overwrite when regenerate !
  * 
 */
public class BusinessParamsDAOQueryBean extends BaseQueryBean {
    
    public BusinessParamsDAOQueryBean() {
		super();
    }
	
    public BusinessParamsDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }
    
    public BusinessParamsDAOQueryBean(BaseQueryBean aQueryBean,Map tableReplaceMap) {
        super(aQueryBean,tableReplaceMap);
    }
    
    public Criteria createCriteria() {
        
	    Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
                  oredCriteria.add(criteria);
            }
        return criteria;
     }
	
    protected Criteria createCriteriaInternal() {
	  return new Criteria(this);
    }
    
        
        
    	
		
	    
    public void addIdSelectProperty(){
		addIdSelectProperty("id");
	}
	
    public void addIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessParamsDAO.Id,aAlias);
		}
		else{
			addSelectProperty(IBusinessParamsDAO.Id,"id");
	    }
    }
    
       
		
		
	    
    public void addBusinessProcessIdSelectProperty(){
		addBusinessProcessIdSelectProperty("businessProcessId");
	}
	
    public void addBusinessProcessIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessParamsDAO.BusinessProcessId,aAlias);
		}
		else{
			addSelectProperty(IBusinessParamsDAO.BusinessProcessId,"businessProcessId");
	    }
    }
    
       
		
		
	    
    public void addBusinessNodeIdSelectProperty(){
		addBusinessNodeIdSelectProperty("businessNodeId");
	}
	
    public void addBusinessNodeIdSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessParamsDAO.BusinessNodeId,aAlias);
		}
		else{
			addSelectProperty(IBusinessParamsDAO.BusinessNodeId,"businessNodeId");
	    }
    }
    
       
		
		
	    
    public void addParamNameSelectProperty(){
		addParamNameSelectProperty("paramName");
	}
	
    public void addParamNameSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessParamsDAO.ParamName,aAlias);
		}
		else{
			addSelectProperty(IBusinessParamsDAO.ParamName,"paramName");
	    }
    }
    
       
		
		
	    
    public void addParamTypeSelectProperty(){
		addParamTypeSelectProperty("paramType");
	}
	
    public void addParamTypeSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessParamsDAO.ParamType,aAlias);
		}
		else{
			addSelectProperty(IBusinessParamsDAO.ParamType,"paramType");
	    }
    }
    
       
		
		
	    
    public void addIsArraySelectProperty(){
		addIsArraySelectProperty("isArray");
	}
	
    public void addIsArraySelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessParamsDAO.IsArray,aAlias);
		}
		else{
			addSelectProperty(IBusinessParamsDAO.IsArray,"isArray");
	    }
    }
    
       
		
		
	    
    public void addDeleteFlagSelectProperty(){
		addDeleteFlagSelectProperty("deleteFlag");
	}
	
    public void addDeleteFlagSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessParamsDAO.DeleteFlag,aAlias);
		}
		else{
			addSelectProperty(IBusinessParamsDAO.DeleteFlag,"deleteFlag");
	    }
    }
    
       
		
		
	    
    public void addStatusSelectProperty(){
		addStatusSelectProperty("status");
	}
	
    public void addStatusSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessParamsDAO.Status,aAlias);
		}
		else{
			addSelectProperty(IBusinessParamsDAO.Status,"status");
	    }
    }
    
       
		
		
	    
    public void addRemarksSelectProperty(){
		addRemarksSelectProperty("remarks");
	}
	
    public void addRemarksSelectProperty(String aAlias){
		if(StringUtils.isNotBlank(aAlias)){
			addSelectProperty(IBusinessParamsDAO.Remarks,aAlias);
		}
		else{
			addSelectProperty(IBusinessParamsDAO.Remarks,"remarks");
	    }
    }
    
       
		
		
	public void addAllSelectProperties(){
		
		
	    addIdSelectProperty();
   
		
		
	    addBusinessProcessIdSelectProperty();
   
		
		
	    addBusinessNodeIdSelectProperty();
   
		
		
	    addParamNameSelectProperty();
   
		
		
	    addParamTypeSelectProperty();
   
		
		
	    addIsArraySelectProperty();
   
		
		
	    addDeleteFlagSelectProperty();
   
		
		
	    addStatusSelectProperty();
   
		
		
	    addRemarksSelectProperty();
   
		
	    }
    
    public static class Criteria extends BaseWhereCriterion<BusinessParamsDAOQueryBean> {
	
        protected Criteria(BusinessParamsDAOQueryBean aParentObject) {
		    super(aParentObject);
        }
        
                  
            	
    	    	
    	        
                
        public Criteria andIdIsNull() {
            addCriterion(IBusinessParamsDAO.Id + " is null");
            return this;
        }
        public Criteria andIdIsNotNull() {
            addCriterion(IBusinessParamsDAO.Id + " is not null");
            return this;
        }
    
        public Criteria andIdIsNotEmpty() {        
            addCriterion(IBusinessParamsDAO.Id + " is not null AND " + IBusinessParamsDAO.Id + " <> ''");
            return this;
        }
    		
    	public Criteria andIdIsEmpty() {       
            addCriterion("(" + IBusinessParamsDAO.Id + " is null OR " + IBusinessParamsDAO.Id + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andIdEqualTo(long value) {
        	return andIdEqualTo(Long.valueOf(value));
        }
               public Criteria andIdEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.Id + " = ", value, "id");
            return this;
        }
        
        public Criteria andIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.Id);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Id + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andIdNotEqualTo(long value) {
        	return andIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IBusinessParamsDAO.Id + " <>", value, "id");
            return this;
        }
               
        public Criteria andIdNotEqualToOrIsNull(long value) {
        	return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IBusinessParamsDAO.Id + " is null OR " + IBusinessParamsDAO.Id + " <>", value, "id");
            return this;
        }
        
        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.Id);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Id + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andIdGreaterThan(long value) {
        	return andIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.Id + " >", value, "id");
            return this;
        }
        
        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.Id);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Id + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andIdGreaterThanOrEqualTo(long value) {
        	return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.Id + " >=", value, "id");
            return this;
        }
        
        public Criteria andIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.Id);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Id + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdLessThan(long value) {
        	return andIdLessThan(Long.valueOf(value));
        }
                public Criteria andIdLessThan(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.Id + " <", value, "id");
            return this;
        }
        
        public Criteria andIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.Id);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Id + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdLessThanOrEqualTo(long value) {
        	return andIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.Id + " <=", value, "id");
            return this;
        }
        
        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.Id);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Id + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andIdIn(long[] values) {
        	if(values.length == 1){
        		return andIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.Id + " in", values, "id");
            	return this;
            }
        }
        
        public Criteria andIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.Id + " not in", values, "id");
            	return this;
            }
        }
        
                public Criteria andIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.Id + " in", values, "id");
            	return this;
            }
        }
        public Criteria andIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.Id + " not in", values, "id");
            	return this;
            }
        }
        
        public Criteria andIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.Id + " in", Arrays.asList(values), "id");
            	return this;
            }
        }
        public Criteria andIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.Id + " not in", Arrays.asList(values), "id");
            	return this;
            }
        }
		
		public Criteria andIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Id + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Id + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andIdBetween(long value1,long value2) {
        	addCriterion(IBusinessParamsDAO.Id + " between", value1, value2, "id");
            return this;
        }
                public Criteria andIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessParamsDAO.Id + " between", value1, value2, "id");
            return this;
        }
        
                
        public Criteria andIdNotBetween(long value1,long value2) {
        	addCriterion(IBusinessParamsDAO.Id + " not between", value1, value2, "id");
            return this;
        }
                public Criteria andIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessParamsDAO.Id + " not between", value1, value2, "id");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andBusinessProcessIdIsNull() {
            addCriterion(IBusinessParamsDAO.BusinessProcessId + " is null");
            return this;
        }
        public Criteria andBusinessProcessIdIsNotNull() {
            addCriterion(IBusinessParamsDAO.BusinessProcessId + " is not null");
            return this;
        }
    
        public Criteria andBusinessProcessIdIsNotEmpty() {        
            addCriterion(IBusinessParamsDAO.BusinessProcessId + " is not null AND " + IBusinessParamsDAO.BusinessProcessId + " <> ''");
            return this;
        }
    		
    	public Criteria andBusinessProcessIdIsEmpty() {       
            addCriterion("(" + IBusinessParamsDAO.BusinessProcessId + " is null OR " + IBusinessParamsDAO.BusinessProcessId + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andBusinessProcessIdEqualTo(long value) {
        	return andBusinessProcessIdEqualTo(Long.valueOf(value));
        }
               public Criteria andBusinessProcessIdEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.BusinessProcessId + " = ", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.BusinessProcessId);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessProcessId + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andBusinessProcessIdNotEqualTo(long value) {
        	return andBusinessProcessIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IBusinessParamsDAO.BusinessProcessId + " <>", value, "businessProcessId");
            return this;
        }
               
        public Criteria andBusinessProcessIdNotEqualToOrIsNull(long value) {
        	return andBusinessProcessIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andBusinessProcessIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IBusinessParamsDAO.BusinessProcessId + " is null OR " + IBusinessParamsDAO.BusinessProcessId + " <>", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.BusinessProcessId);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessProcessId + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andBusinessProcessIdGreaterThan(long value) {
        	return andBusinessProcessIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.BusinessProcessId + " >", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.BusinessProcessId);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessProcessId + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andBusinessProcessIdGreaterThanOrEqualTo(long value) {
        	return andBusinessProcessIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.BusinessProcessId + " >=", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.BusinessProcessId);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessProcessId + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andBusinessProcessIdLessThan(long value) {
        	return andBusinessProcessIdLessThan(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdLessThan(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.BusinessProcessId + " <", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.BusinessProcessId);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessProcessId + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andBusinessProcessIdLessThanOrEqualTo(long value) {
        	return andBusinessProcessIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andBusinessProcessIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.BusinessProcessId + " <=", value, "businessProcessId");
            return this;
        }
        
        public Criteria andBusinessProcessIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.BusinessProcessId);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessProcessIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessProcessId + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andBusinessProcessIdIn(long[] values) {
        	if(values.length == 1){
        		return andBusinessProcessIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.BusinessProcessId + " in", values, "businessProcessId");
            	return this;
            }
        }
        
        public Criteria andBusinessProcessIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andBusinessProcessIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.BusinessProcessId + " not in", values, "businessProcessId");
            	return this;
            }
        }
        
                public Criteria andBusinessProcessIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andBusinessProcessIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.BusinessProcessId + " in", values, "businessProcessId");
            	return this;
            }
        }
        public Criteria andBusinessProcessIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andBusinessProcessIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.BusinessProcessId + " not in", values, "businessProcessId");
            	return this;
            }
        }
        
        public Criteria andBusinessProcessIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andBusinessProcessIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.BusinessProcessId + " in", Arrays.asList(values), "businessProcessId");
            	return this;
            }
        }
        public Criteria andBusinessProcessIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andBusinessProcessIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.BusinessProcessId + " not in", Arrays.asList(values), "businessProcessId");
            	return this;
            }
        }
		
		public Criteria andBusinessProcessIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessProcessId + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andBusinessProcessIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessProcessId + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andBusinessProcessIdBetween(long value1,long value2) {
        	addCriterion(IBusinessParamsDAO.BusinessProcessId + " between", value1, value2, "businessProcessId");
            return this;
        }
                public Criteria andBusinessProcessIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessParamsDAO.BusinessProcessId + " between", value1, value2, "businessProcessId");
            return this;
        }
        
                
        public Criteria andBusinessProcessIdNotBetween(long value1,long value2) {
        	addCriterion(IBusinessParamsDAO.BusinessProcessId + " not between", value1, value2, "businessProcessId");
            return this;
        }
                public Criteria andBusinessProcessIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessParamsDAO.BusinessProcessId + " not between", value1, value2, "businessProcessId");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andBusinessNodeIdIsNull() {
            addCriterion(IBusinessParamsDAO.BusinessNodeId + " is null");
            return this;
        }
        public Criteria andBusinessNodeIdIsNotNull() {
            addCriterion(IBusinessParamsDAO.BusinessNodeId + " is not null");
            return this;
        }
    
        public Criteria andBusinessNodeIdIsNotEmpty() {        
            addCriterion(IBusinessParamsDAO.BusinessNodeId + " is not null AND " + IBusinessParamsDAO.BusinessNodeId + " <> ''");
            return this;
        }
    		
    	public Criteria andBusinessNodeIdIsEmpty() {       
            addCriterion("(" + IBusinessParamsDAO.BusinessNodeId + " is null OR " + IBusinessParamsDAO.BusinessNodeId + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andBusinessNodeIdEqualTo(long value) {
        	return andBusinessNodeIdEqualTo(Long.valueOf(value));
        }
               public Criteria andBusinessNodeIdEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.BusinessNodeId + " = ", value, "businessNodeId");
            return this;
        }
        
        public Criteria andBusinessNodeIdEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.BusinessNodeId);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeIdEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessNodeId + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andBusinessNodeIdNotEqualTo(long value) {
        	return andBusinessNodeIdNotEqualTo(Long.valueOf(value));
        }
                public Criteria andBusinessNodeIdNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IBusinessParamsDAO.BusinessNodeId + " <>", value, "businessNodeId");
            return this;
        }
               
        public Criteria andBusinessNodeIdNotEqualToOrIsNull(long value) {
        	return andBusinessNodeIdNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andBusinessNodeIdNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IBusinessParamsDAO.BusinessNodeId + " is null OR " + IBusinessParamsDAO.BusinessNodeId + " <>", value, "businessNodeId");
            return this;
        }
        
        public Criteria andBusinessNodeIdNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.BusinessNodeId);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeIdNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessNodeId + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andBusinessNodeIdGreaterThan(long value) {
        	return andBusinessNodeIdGreaterThan(Long.valueOf(value));
        }
                public Criteria andBusinessNodeIdGreaterThan(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.BusinessNodeId + " >", value, "businessNodeId");
            return this;
        }
        
        public Criteria andBusinessNodeIdGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.BusinessNodeId);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeIdGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessNodeId + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andBusinessNodeIdGreaterThanOrEqualTo(long value) {
        	return andBusinessNodeIdGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andBusinessNodeIdGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.BusinessNodeId + " >=", value, "businessNodeId");
            return this;
        }
        
        public Criteria andBusinessNodeIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.BusinessNodeId);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessNodeId + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andBusinessNodeIdLessThan(long value) {
        	return andBusinessNodeIdLessThan(Long.valueOf(value));
        }
                public Criteria andBusinessNodeIdLessThan(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.BusinessNodeId + " <", value, "businessNodeId");
            return this;
        }
        
        public Criteria andBusinessNodeIdLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.BusinessNodeId);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeIdLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessNodeId + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andBusinessNodeIdLessThanOrEqualTo(long value) {
        	return andBusinessNodeIdLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andBusinessNodeIdLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.BusinessNodeId + " <=", value, "businessNodeId");
            return this;
        }
        
        public Criteria andBusinessNodeIdLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.BusinessNodeId);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andBusinessNodeIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessNodeId + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andBusinessNodeIdIn(long[] values) {
        	if(values.length == 1){
        		return andBusinessNodeIdEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.BusinessNodeId + " in", values, "businessNodeId");
            	return this;
            }
        }
        
        public Criteria andBusinessNodeIdNotIn(long[] values) {
        	if(values.length == 1){
        		return andBusinessNodeIdNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.BusinessNodeId + " not in", values, "businessNodeId");
            	return this;
            }
        }
        
                public Criteria andBusinessNodeIdIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andBusinessNodeIdEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.BusinessNodeId + " in", values, "businessNodeId");
            	return this;
            }
        }
        public Criteria andBusinessNodeIdNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andBusinessNodeIdNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.BusinessNodeId + " not in", values, "businessNodeId");
            	return this;
            }
        }
        
        public Criteria andBusinessNodeIdIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andBusinessNodeIdEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.BusinessNodeId + " in", Arrays.asList(values), "businessNodeId");
            	return this;
            }
        }
        public Criteria andBusinessNodeIdNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andBusinessNodeIdNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.BusinessNodeId + " not in", Arrays.asList(values), "businessNodeId");
            	return this;
            }
        }
		
		public Criteria andBusinessNodeIdIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessNodeId + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andBusinessNodeIdNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.BusinessNodeId + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andBusinessNodeIdBetween(long value1,long value2) {
        	addCriterion(IBusinessParamsDAO.BusinessNodeId + " between", value1, value2, "businessNodeId");
            return this;
        }
                public Criteria andBusinessNodeIdBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessParamsDAO.BusinessNodeId + " between", value1, value2, "businessNodeId");
            return this;
        }
        
                
        public Criteria andBusinessNodeIdNotBetween(long value1,long value2) {
        	addCriterion(IBusinessParamsDAO.BusinessNodeId + " not between", value1, value2, "businessNodeId");
            return this;
        }
                public Criteria andBusinessNodeIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessParamsDAO.BusinessNodeId + " not between", value1, value2, "businessNodeId");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andParamNameIsNull() {
            addCriterion(IBusinessParamsDAO.ParamName + " is null");
            return this;
        }
        public Criteria andParamNameIsNotNull() {
            addCriterion(IBusinessParamsDAO.ParamName + " is not null");
            return this;
        }
    
        public Criteria andParamNameIsNotEmpty() {        
            addCriterion(IBusinessParamsDAO.ParamName + " is not null AND " + IBusinessParamsDAO.ParamName + " <> ''");
            return this;
        }
    		
    	public Criteria andParamNameIsEmpty() {       
            addCriterion("(" + IBusinessParamsDAO.ParamName + " is null OR " + IBusinessParamsDAO.ParamName + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andParamNameEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.ParamName + " = ", value, "paramName");
            return this;
        }
        
        public Criteria andParamNameEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.ParamName);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParamNameEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamName + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andParamNameNotEqualTo(String value) {
        	        
            addCriterion(IBusinessParamsDAO.ParamName + " <>", value, "paramName");
            return this;
        }
               
        public Criteria andParamNameNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IBusinessParamsDAO.ParamName + " is null OR " + IBusinessParamsDAO.ParamName + " <>", value, "paramName");
            return this;
        }
        
        public Criteria andParamNameNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.ParamName);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParamNameNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamName + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andParamNameGreaterThan(String value) {
        				
            addCriterion(IBusinessParamsDAO.ParamName + " >", value, "paramName");
            return this;
        }
        
        public Criteria andParamNameGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.ParamName);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParamNameGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamName + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andParamNameGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.ParamName + " >=", value, "paramName");
            return this;
        }
        
        public Criteria andParamNameGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.ParamName);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParamNameGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamName + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andParamNameLessThan(String value) {
        				
            addCriterion(IBusinessParamsDAO.ParamName + " <", value, "paramName");
            return this;
        }
        
        public Criteria andParamNameLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.ParamName);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParamNameLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamName + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andParamNameLessThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.ParamName + " <=", value, "paramName");
            return this;
        }
        
        public Criteria andParamNameLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.ParamName);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParamNameLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamName + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andParamNameLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessParamsDAO.ParamName + " like", buffer.toString(), "paramName");
            return this;
        }
        public Criteria andParamNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessParamsDAO.ParamName + " not like", buffer.toString(), "paramName");
            return this;
        }
                
                public Criteria andParamNameIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andParamNameEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.ParamName + " in", values, "paramName");
            	return this;
            }
        }
        public Criteria andParamNameNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andParamNameNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.ParamName + " not in", values, "paramName");
            	return this;
            }
        }
        
        public Criteria andParamNameIn(String[] values) {
        	
        	if(values.length == 1){
        		return andParamNameEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.ParamName + " in", Arrays.asList(values), "paramName");
            	return this;
            }
        }
        public Criteria andParamNameNotIn(String[] values) {
        	if(values.length == 1){
        		return andParamNameNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.ParamName + " not in", Arrays.asList(values), "paramName");
            	return this;
            }
        }
		
		public Criteria andParamNameIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamName + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andParamNameNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamName + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andParamNameBetween(String value1, String value2) {
            addCriterion(IBusinessParamsDAO.ParamName + " between", value1, value2, "paramName");
            return this;
        }
        
                public Criteria andParamNameNotBetween(String value1, String value2) {
            addCriterion(IBusinessParamsDAO.ParamName + " not between", value1, value2, "paramName");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andParamTypeIsNull() {
            addCriterion(IBusinessParamsDAO.ParamType + " is null");
            return this;
        }
        public Criteria andParamTypeIsNotNull() {
            addCriterion(IBusinessParamsDAO.ParamType + " is not null");
            return this;
        }
    
        public Criteria andParamTypeIsNotEmpty() {        
            addCriterion(IBusinessParamsDAO.ParamType + " is not null AND " + IBusinessParamsDAO.ParamType + " <> ''");
            return this;
        }
    		
    	public Criteria andParamTypeIsEmpty() {       
            addCriterion("(" + IBusinessParamsDAO.ParamType + " is null OR " + IBusinessParamsDAO.ParamType + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andParamTypeEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.ParamType + " = ", value, "paramType");
            return this;
        }
        
        public Criteria andParamTypeEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.ParamType);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParamTypeEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamType + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andParamTypeNotEqualTo(String value) {
        	        
            addCriterion(IBusinessParamsDAO.ParamType + " <>", value, "paramType");
            return this;
        }
               
        public Criteria andParamTypeNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IBusinessParamsDAO.ParamType + " is null OR " + IBusinessParamsDAO.ParamType + " <>", value, "paramType");
            return this;
        }
        
        public Criteria andParamTypeNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.ParamType);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParamTypeNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamType + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andParamTypeGreaterThan(String value) {
        				
            addCriterion(IBusinessParamsDAO.ParamType + " >", value, "paramType");
            return this;
        }
        
        public Criteria andParamTypeGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.ParamType);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParamTypeGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamType + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andParamTypeGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.ParamType + " >=", value, "paramType");
            return this;
        }
        
        public Criteria andParamTypeGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.ParamType);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParamTypeGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamType + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andParamTypeLessThan(String value) {
        				
            addCriterion(IBusinessParamsDAO.ParamType + " <", value, "paramType");
            return this;
        }
        
        public Criteria andParamTypeLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.ParamType);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParamTypeLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamType + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andParamTypeLessThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.ParamType + " <=", value, "paramType");
            return this;
        }
        
        public Criteria andParamTypeLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.ParamType);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andParamTypeLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamType + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andParamTypeLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessParamsDAO.ParamType + " like", buffer.toString(), "paramType");
            return this;
        }
        public Criteria andParamTypeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessParamsDAO.ParamType + " not like", buffer.toString(), "paramType");
            return this;
        }
                
                public Criteria andParamTypeIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andParamTypeEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.ParamType + " in", values, "paramType");
            	return this;
            }
        }
        public Criteria andParamTypeNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andParamTypeNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.ParamType + " not in", values, "paramType");
            	return this;
            }
        }
        
        public Criteria andParamTypeIn(String[] values) {
        	
        	if(values.length == 1){
        		return andParamTypeEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.ParamType + " in", Arrays.asList(values), "paramType");
            	return this;
            }
        }
        public Criteria andParamTypeNotIn(String[] values) {
        	if(values.length == 1){
        		return andParamTypeNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.ParamType + " not in", Arrays.asList(values), "paramType");
            	return this;
            }
        }
		
		public Criteria andParamTypeIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamType + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andParamTypeNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.ParamType + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andParamTypeBetween(String value1, String value2) {
            addCriterion(IBusinessParamsDAO.ParamType + " between", value1, value2, "paramType");
            return this;
        }
        
                public Criteria andParamTypeNotBetween(String value1, String value2) {
            addCriterion(IBusinessParamsDAO.ParamType + " not between", value1, value2, "paramType");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andIsArrayIsNull() {
            addCriterion(IBusinessParamsDAO.IsArray + " is null");
            return this;
        }
        public Criteria andIsArrayIsNotNull() {
            addCriterion(IBusinessParamsDAO.IsArray + " is not null");
            return this;
        }
    
        public Criteria andIsArrayIsNotEmpty() {        
            addCriterion(IBusinessParamsDAO.IsArray + " is not null AND " + IBusinessParamsDAO.IsArray + " <> ''");
            return this;
        }
    		
    	public Criteria andIsArrayIsEmpty() {       
            addCriterion("(" + IBusinessParamsDAO.IsArray + " is null OR " + IBusinessParamsDAO.IsArray + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andIsArrayEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.IsArray + " = ", value, "isArray");
            return this;
        }
        
        public Criteria andIsArrayEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.IsArray);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIsArrayEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.IsArray + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andIsArrayNotEqualTo(String value) {
        	        
            addCriterion(IBusinessParamsDAO.IsArray + " <>", value, "isArray");
            return this;
        }
               
        public Criteria andIsArrayNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IBusinessParamsDAO.IsArray + " is null OR " + IBusinessParamsDAO.IsArray + " <>", value, "isArray");
            return this;
        }
        
        public Criteria andIsArrayNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.IsArray);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIsArrayNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.IsArray + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andIsArrayGreaterThan(String value) {
        				
            addCriterion(IBusinessParamsDAO.IsArray + " >", value, "isArray");
            return this;
        }
        
        public Criteria andIsArrayGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.IsArray);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIsArrayGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.IsArray + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andIsArrayGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.IsArray + " >=", value, "isArray");
            return this;
        }
        
        public Criteria andIsArrayGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.IsArray);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIsArrayGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.IsArray + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andIsArrayLessThan(String value) {
        				
            addCriterion(IBusinessParamsDAO.IsArray + " <", value, "isArray");
            return this;
        }
        
        public Criteria andIsArrayLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.IsArray);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIsArrayLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.IsArray + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andIsArrayLessThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.IsArray + " <=", value, "isArray");
            return this;
        }
        
        public Criteria andIsArrayLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.IsArray);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andIsArrayLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.IsArray + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andIsArrayLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessParamsDAO.IsArray + " like", buffer.toString(), "isArray");
            return this;
        }
        public Criteria andIsArrayNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessParamsDAO.IsArray + " not like", buffer.toString(), "isArray");
            return this;
        }
                
                public Criteria andIsArrayIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andIsArrayEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.IsArray + " in", values, "isArray");
            	return this;
            }
        }
        public Criteria andIsArrayNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andIsArrayNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.IsArray + " not in", values, "isArray");
            	return this;
            }
        }
        
        public Criteria andIsArrayIn(String[] values) {
        	
        	if(values.length == 1){
        		return andIsArrayEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.IsArray + " in", Arrays.asList(values), "isArray");
            	return this;
            }
        }
        public Criteria andIsArrayNotIn(String[] values) {
        	if(values.length == 1){
        		return andIsArrayNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.IsArray + " not in", Arrays.asList(values), "isArray");
            	return this;
            }
        }
		
		public Criteria andIsArrayIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.IsArray + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andIsArrayNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.IsArray + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andIsArrayBetween(String value1, String value2) {
            addCriterion(IBusinessParamsDAO.IsArray + " between", value1, value2, "isArray");
            return this;
        }
        
                public Criteria andIsArrayNotBetween(String value1, String value2) {
            addCriterion(IBusinessParamsDAO.IsArray + " not between", value1, value2, "isArray");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andDeleteFlagIsNull() {
            addCriterion(IBusinessParamsDAO.DeleteFlag + " is null");
            return this;
        }
        public Criteria andDeleteFlagIsNotNull() {
            addCriterion(IBusinessParamsDAO.DeleteFlag + " is not null");
            return this;
        }
    
        public Criteria andDeleteFlagIsNotEmpty() {        
            addCriterion(IBusinessParamsDAO.DeleteFlag + " is not null AND " + IBusinessParamsDAO.DeleteFlag + " <> ''");
            return this;
        }
    		
    	public Criteria andDeleteFlagIsEmpty() {       
            addCriterion("(" + IBusinessParamsDAO.DeleteFlag + " is null OR " + IBusinessParamsDAO.DeleteFlag + " = '')");
            return this;
        }
        
                
                        
                        
                                
        public Criteria andDeleteFlagEqualTo(long value) {
        	return andDeleteFlagEqualTo(Long.valueOf(value));
        }
               public Criteria andDeleteFlagEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.DeleteFlag + " = ", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.DeleteFlag);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.DeleteFlag + " = ", subQueryBean, dao);
			return this;
		}
                
        public Criteria andDeleteFlagNotEqualTo(long value) {
        	return andDeleteFlagNotEqualTo(Long.valueOf(value));
        }
                public Criteria andDeleteFlagNotEqualTo(java.lang.Long value) {
        	        
            addCriterion(IBusinessParamsDAO.DeleteFlag + " <>", value, "deleteFlag");
            return this;
        }
               
        public Criteria andDeleteFlagNotEqualToOrIsNull(long value) {
        	return andDeleteFlagNotEqualToOrIsNull(Long.valueOf(value));
        }
                
        public Criteria andDeleteFlagNotEqualToOrIsNull(java.lang.Long value) {
        	        
            addCriterion(IBusinessParamsDAO.DeleteFlag + " is null OR " + IBusinessParamsDAO.DeleteFlag + " <>", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.DeleteFlag);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.DeleteFlag + " <> ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andDeleteFlagGreaterThan(long value) {
        	return andDeleteFlagGreaterThan(Long.valueOf(value));
        }
                public Criteria andDeleteFlagGreaterThan(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.DeleteFlag + " >", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.DeleteFlag);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.DeleteFlag + " > ", subQueryBean, dao);
			return this;
		}
               
        public Criteria andDeleteFlagGreaterThanOrEqualTo(long value) {
        	return andDeleteFlagGreaterThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andDeleteFlagGreaterThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.DeleteFlag + " >=", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.DeleteFlag);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.DeleteFlag + " >= ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagLessThan(long value) {
        	return andDeleteFlagLessThan(Long.valueOf(value));
        }
                public Criteria andDeleteFlagLessThan(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.DeleteFlag + " <", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.DeleteFlag);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.DeleteFlag + " < ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagLessThanOrEqualTo(long value) {
        	return andDeleteFlagLessThanOrEqualTo(Long.valueOf(value));
        }
                public Criteria andDeleteFlagLessThanOrEqualTo(java.lang.Long value) {
        				
            addCriterion(IBusinessParamsDAO.DeleteFlag + " <=", value, "deleteFlag");
            return this;
        }
        
        public Criteria andDeleteFlagLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.DeleteFlag);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andDeleteFlagLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.DeleteFlag + " <= ", subQueryBean, dao);
			return this;
		}
		
		        
                
        public Criteria andDeleteFlagIn(long[] values) {
        	if(values.length == 1){
        		return andDeleteFlagEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.DeleteFlag + " in", values, "deleteFlag");
            	return this;
            }
        }
        
        public Criteria andDeleteFlagNotIn(long[] values) {
        	if(values.length == 1){
        		return andDeleteFlagNotEqualTo((java.lang.Long)values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.DeleteFlag + " not in", values, "deleteFlag");
            	return this;
            }
        }
        
                public Criteria andDeleteFlagIn(List<java.lang.Long> values) {
        	
        	if(values.size() == 1){
        		return andDeleteFlagEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.DeleteFlag + " in", values, "deleteFlag");
            	return this;
            }
        }
        public Criteria andDeleteFlagNotIn(List<java.lang.Long> values) {
        	if(values.size() == 1){
        		return andDeleteFlagNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.DeleteFlag + " not in", values, "deleteFlag");
            	return this;
            }
        }
        
        public Criteria andDeleteFlagIn(java.lang.Long[] values) {
        	
        	if(values.length == 1){
        		return andDeleteFlagEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.DeleteFlag + " in", Arrays.asList(values), "deleteFlag");
            	return this;
            }
        }
        public Criteria andDeleteFlagNotIn(java.lang.Long[] values) {
        	if(values.length == 1){
        		return andDeleteFlagNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.DeleteFlag + " not in", Arrays.asList(values), "deleteFlag");
            	return this;
            }
        }
		
		public Criteria andDeleteFlagIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.DeleteFlag + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andDeleteFlagNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.DeleteFlag + " not in ", subQueryBean, dao);
			return this;
		}
        
                
        public Criteria andDeleteFlagBetween(long value1,long value2) {
        	addCriterion(IBusinessParamsDAO.DeleteFlag + " between", value1, value2, "deleteFlag");
            return this;
        }
                public Criteria andDeleteFlagBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessParamsDAO.DeleteFlag + " between", value1, value2, "deleteFlag");
            return this;
        }
        
                
        public Criteria andDeleteFlagNotBetween(long value1,long value2) {
        	addCriterion(IBusinessParamsDAO.DeleteFlag + " not between", value1, value2, "deleteFlag");
            return this;
        }
                public Criteria andDeleteFlagNotBetween(java.lang.Long value1, java.lang.Long value2) {
            addCriterion(IBusinessParamsDAO.DeleteFlag + " not between", value1, value2, "deleteFlag");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andStatusIsNull() {
            addCriterion(IBusinessParamsDAO.Status + " is null");
            return this;
        }
        public Criteria andStatusIsNotNull() {
            addCriterion(IBusinessParamsDAO.Status + " is not null");
            return this;
        }
    
        public Criteria andStatusIsNotEmpty() {        
            addCriterion(IBusinessParamsDAO.Status + " is not null AND " + IBusinessParamsDAO.Status + " <> ''");
            return this;
        }
    		
    	public Criteria andStatusIsEmpty() {       
            addCriterion("(" + IBusinessParamsDAO.Status + " is null OR " + IBusinessParamsDAO.Status + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andStatusEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.Status + " = ", value, "status");
            return this;
        }
        
        public Criteria andStatusEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.Status);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Status + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andStatusNotEqualTo(String value) {
        	        
            addCriterion(IBusinessParamsDAO.Status + " <>", value, "status");
            return this;
        }
               
        public Criteria andStatusNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IBusinessParamsDAO.Status + " is null OR " + IBusinessParamsDAO.Status + " <>", value, "status");
            return this;
        }
        
        public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.Status);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Status + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andStatusGreaterThan(String value) {
        				
            addCriterion(IBusinessParamsDAO.Status + " >", value, "status");
            return this;
        }
        
        public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.Status);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Status + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andStatusGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.Status + " >=", value, "status");
            return this;
        }
        
        public Criteria andStatusGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.Status);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Status + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusLessThan(String value) {
        				
            addCriterion(IBusinessParamsDAO.Status + " <", value, "status");
            return this;
        }
        
        public Criteria andStatusLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.Status);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Status + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusLessThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.Status + " <=", value, "status");
            return this;
        }
        
        public Criteria andStatusLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.Status);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andStatusLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Status + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andStatusLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessParamsDAO.Status + " like", buffer.toString(), "status");
            return this;
        }
        public Criteria andStatusNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessParamsDAO.Status + " not like", buffer.toString(), "status");
            return this;
        }
                
                public Criteria andStatusIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andStatusEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.Status + " in", values, "status");
            	return this;
            }
        }
        public Criteria andStatusNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andStatusNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.Status + " not in", values, "status");
            	return this;
            }
        }
        
        public Criteria andStatusIn(String[] values) {
        	
        	if(values.length == 1){
        		return andStatusEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.Status + " in", Arrays.asList(values), "status");
            	return this;
            }
        }
        public Criteria andStatusNotIn(String[] values) {
        	if(values.length == 1){
        		return andStatusNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.Status + " not in", Arrays.asList(values), "status");
            	return this;
            }
        }
		
		public Criteria andStatusIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Status + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andStatusNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Status + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andStatusBetween(String value1, String value2) {
            addCriterion(IBusinessParamsDAO.Status + " between", value1, value2, "status");
            return this;
        }
        
                public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion(IBusinessParamsDAO.Status + " not between", value1, value2, "status");
            return this;
        }
        
            	
    	    	
    	    	
    	        
                
        public Criteria andRemarksIsNull() {
            addCriterion(IBusinessParamsDAO.Remarks + " is null");
            return this;
        }
        public Criteria andRemarksIsNotNull() {
            addCriterion(IBusinessParamsDAO.Remarks + " is not null");
            return this;
        }
    
        public Criteria andRemarksIsNotEmpty() {        
            addCriterion(IBusinessParamsDAO.Remarks + " is not null AND " + IBusinessParamsDAO.Remarks + " <> ''");
            return this;
        }
    		
    	public Criteria andRemarksIsEmpty() {       
            addCriterion("(" + IBusinessParamsDAO.Remarks + " is null OR " + IBusinessParamsDAO.Remarks + " = '')");
            return this;
        }
        
                
                        
                        
                               public Criteria andRemarksEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.Remarks + " = ", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.Remarks);
	    str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Remarks + " = ", subQueryBean, dao);
			return this;
		}
                public Criteria andRemarksNotEqualTo(String value) {
        	        
            addCriterion(IBusinessParamsDAO.Remarks + " <>", value, "remarks");
            return this;
        }
               
        public Criteria andRemarksNotEqualToOrIsNull(String value) {
        	        
            addCriterion(IBusinessParamsDAO.Remarks + " is null OR " + IBusinessParamsDAO.Remarks + " <>", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksNotEqualToForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.Remarks);
	    str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksNotEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Remarks + " <> ", subQueryBean, dao);
			return this;
		}
               public Criteria andRemarksGreaterThan(String value) {
        				
            addCriterion(IBusinessParamsDAO.Remarks + " >", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksGreaterThanForeignKey(java.lang.String key) {
	    StringBuffer str = new StringBuffer(IBusinessParamsDAO.Remarks);
	    str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksGreaterThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Remarks + " > ", subQueryBean, dao);
			return this;
		}
               public Criteria andRemarksGreaterThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.Remarks + " >=", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksGreaterThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.Remarks);
			str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Remarks + " >= ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksLessThan(String value) {
        				
            addCriterion(IBusinessParamsDAO.Remarks + " <", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksLessThanForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.Remarks);
			str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksLessThan(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Remarks + " < ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksLessThanOrEqualTo(String value) {
        				
            addCriterion(IBusinessParamsDAO.Remarks + " <=", value, "remarks");
            return this;
        }
        
        public Criteria andRemarksLessThanOrEqualToForeignKey(java.lang.String key) {
			StringBuffer str = new StringBuffer(IBusinessParamsDAO.Remarks);
			str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());
            return this;
        }
		
		public Criteria andRemarksLessThanOrEqualTo(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Remarks + " <= ", subQueryBean, dao);
			return this;
		}
		
				
        public Criteria andRemarksLike(String value) {
        	StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessParamsDAO.Remarks + " like", buffer.toString(), "remarks");
            return this;
        }
        public Criteria andRemarksNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
        	buffer.append(value);
        	buffer.append("%");
            addCriterion(IBusinessParamsDAO.Remarks + " not like", buffer.toString(), "remarks");
            return this;
        }
                
                public Criteria andRemarksIn(List<String> values) {
        	
        	if(values.size() == 1){
        		return andRemarksEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.Remarks + " in", values, "remarks");
            	return this;
            }
        }
        public Criteria andRemarksNotIn(List<String> values) {
        	if(values.size() == 1){
        		return andRemarksNotEqualTo(values.get(0));
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.Remarks + " not in", values, "remarks");
            	return this;
            }
        }
        
        public Criteria andRemarksIn(String[] values) {
        	
        	if(values.length == 1){
        		return andRemarksEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.Remarks + " in", Arrays.asList(values), "remarks");
            	return this;
            }
        }
        public Criteria andRemarksNotIn(String[] values) {
        	if(values.length == 1){
        		return andRemarksNotEqualTo(values[0]);
        	}
        	else{
            	addCriterion(IBusinessParamsDAO.Remarks + " not in", Arrays.asList(values), "remarks");
            	return this;
            }
        }
		
		public Criteria andRemarksIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Remarks + " in ", subQueryBean, dao);
			return this;
		}
		
		public Criteria andRemarksNotIn(BaseQueryBean subQueryBean,
				IDataAccessInterface<?, ?> dao) {
			addCriterion(IBusinessParamsDAO.Remarks + " not in ", subQueryBean, dao);
			return this;
		}
        
                public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion(IBusinessParamsDAO.Remarks + " between", value1, value2, "remarks");
            return this;
        }
        
                public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion(IBusinessParamsDAO.Remarks + " not between", value1, value2, "remarks");
            return this;
        }
        
            	
    	    	
    	        
        
    }
	
    
}